<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="${file.pkg_this}.${bean.entityName}">
	<!-- 基本分页查询  -->
	<select id="select_${func._su.toSqlName(bean.entityName)!}_page" parameterType="request" resultMap="_${bean.entityName}_RM">
		SELECT t.* FROM ${bean.tableName} t 
		<where>
			<#list bean.properties as it>
			<if test="codex.${it.name}!=null"> AND t.${it.column} = ${r'#'}{codex.${it.name}}</if>
			</#list>
		</where>
		<include refid="_orders"/>
	</select>
</mapper>